
README File for replication of “Motivation Crowding in Peer Effects: The Effect of Solar Subsidies on Green Power Purchases”, by Andrea La Nauze. 
*************************



SOFTWARE 

The Software used was Stata16 and all results generated on a Mac running macOS Big Sur Version 11.5


DATA

The household-level billing records used in this paper were made available under a non-disclosure agreement with the web portal provider Billcap. Researchers can contact Billcap directly to request data access. Permission to access these data will be granted on a case-by-case basis. Additional files can be sought by those with permission from: a.lanauze@uq.edu.au


INCLUDED FILES

The replication package includes the do files involved in estimation and most of the preparatory (importing and cleaning) files. Some preparatory do files contain information that potentially violates confidentiality. To access these files please contact Andrea La Nauze (a.lanauze@uq.edu.au) with a copy of your agreement with Billcap. All do files available in the repository are listed in the MasterRep.do file and files that are not available in the repository are listed in the MasterRep.do file and commented out.  

The replication files included are: 

MASTER

MasterRep.do // Master file. Run this file to produce all datafiles and results (see REPLICATION below)

IMPORTING AND MERGING

doFilesRep/Import_solaraccounts.do // imports solar start date and first date 
doFilesRep/Import_installdata.do // imports postcode level PV penetration
doFilesRep/Import_locations.do // imports location 
doFilesRep/Import_censusdata_2011.do // imports census data for 2011
doFilesRep/Import_censusdata.do // imports census data for 2006 and 2016, combines with 2011
doFilesRep/Import_moduleprices.do // imports module prices from BNEF
doFilesRep/Import_quarterlyhousepricedata.do // imports house and unit price data 
doFilesRep/Import_buildingstructure.do // imports house and unit price data 
doFilesRep/Import_SA3_bypostcode.do // import SA3 (municipal) postcode match
doFilesRep/Import_postcode_area.do // import area of postcodes
doFilesRep/Merge_accounts_inventory.do // merges accounts panel to inventory panel
doFilesRep/Merge_accounts_PV.do // merges accounts and inventory to solar accounts data and PV penetration data

SAMPLES 

doFilesRep/Identify_eventstudysample_since2006.do // codes events, merges other data, collapses to quarterly postcode data
doFilesRep/Identify_eventstudysample_withsolar.do  // as above, but keeps solar households 
doFilesRep/Identify_individualwithsolarsample.do // for individual level data 
doFilesRep/EstimationSample.do  // keeps sample for estimation , i.e. post 2009
doFilesRep/Merge_sales_estimation.do // merge sales channels with estimation data 
doFilesRep/Lasso.do // run lasso to pick controls

ANALYSIS
* TABLES

* paper 
* Table 1 subsidy changes
doFilesRep/Table2.do 
doFilesRep/Table3.do 
doFilesRep/Table4.do 
doFilesRep/Table5a.do 
doFilesRep/Table5b.do 

* appendix 
* Table A1 see doFiles/Table2.do 
doFilesRep/TableA2.do
doFilesRep/TableA3.do
doFilesRep/TableA4.do
doFilesRep/TableA5.do
doFilesRep/TableA6.do
doFilesRep/TableA7.do
doFilesRep/TableA8.do
doFilesRep/TableA9.do
doFilesRep/TableA10.do
doFilesRep/TableA11.do
doFilesRep/TableA12.do
doFilesRep/TableA13.do
doFilesRep/TableA14.do
doFilesRep/TableA15.do
doFilesRep/TableA16.do
doFilesRep/TableA17.do
doFilesRep/TableA18.do
doFilesRep/TableA19.do
doFilesRep/TableA20.do
doFilesRep/TableA21.do

* FIGURES 

* paper 
doFilesRep/Figure1a.do 
doFilesRep/Figure1b.do 
doFilesRep/Figure2ab.do 
doFilesRep/Figure2c.do 
doFilesRep/Figure3.do 
doFilesRep/Figure6.do 
doFilesRep/Figure457.do  

* appendix 
doFilesRep/FigureA2.do 
doFilesRep/FigureA3.do  
doFilesRep/FigureA4.do  
doFilesRep/FigureA5.do  
doFilesRep/FigureA7.do  
doFilesRep/FigureA8.do  
doFilesRep/FigureA9.do  
doFilesRep/FigureA10.do  
doFilesRep/FigureA11.do  
doFilesRep/FigureA12.do 
doFilesRep/FigureA13.do 
doFilesRep/FigureA14.do  
doFilesRep/FigureA15ab.do  
doFilesRep/FigureA15cdA16.do 
doFilesRep/FigureA17.do /
doFilesRep/FigureA17_Placebo
doFilesRep/FigureA17_TabulatePlot_placebo
doFilesRep/FigureA17_Export_placebo_PV
doFilesRep/FigureA18.do 
doFilesRep/FigureA19.do 



DATA DICTIONARY

Variables used in analysis: 

Variable			Description							Source

cuminstallalltions	Cumulative number of solar panels installed 			Clean Energy Regulator via Australian Photovoltaic Institute
newinstallations 	New solar panel installations 					Clean Energy Regulator via Australian Photovoltaic Institute
quarter 			Quarterly date							Retailer data
green_plan 		Share of new contracts that include green power			Retailer data
NCustomers		Number of new customer contracts 					Retailer data
has_solar		Customer currently has solar (indicator)				Retailer data
ever_solar		Customer ever observed with solar (indicator)			Retailer data
Salesdriven 		Customer acquired via direct marketing efforts 			Retailer data
Consumerdriven		Customer acquired via indirect marketing efforts			Retailer data
not_concession 		Customer does not hold low income concession card			Retailer data
not_direct		Customer chose not to auto debit bills from nominated account	Retailer data
price_green		Average price paid by green customers per kWh of electricity 	Retailer data
postcode 		Postcode of contract						Retailer data
ROOFME			Number of metal roofs 						NEXIS from GeoScience Australia
PROOFME			Proportion of roofs that are metal 				NEXIS from GeoScience Australia
ROOFTI			Number of tile roofs						NEXIS from GeoScience Australia
SA3_CODE			Code for Statistical Area 3 					Australian Bureau of Statistics
area			Postcode area 							Australian Bureau of Statistics
median_income_interp 	Interpolated median income 					Australian Bureau of Statistics Census 
median_mortgage_interp	Interpolated mortgage payment					Australian Bureau of Statistics Census 
PBachelor_interp 	Interpolated proportion population with Bachelor degree		Australian Bureau of Statistics Census 
PFullTime_interp		Interpolated proportion population working full time 		Australian Bureau of Statistics Census 
TotalHouse_interp	Interpolated total number of dwellings				Australian Bureau of Statistics Census 
moduleprice		Global solar module price index 					Bloomberg New Energy Finance
roofrelativeIV		Relative roof instrument						Constructed 
event_*			Event time variables 						Constructed



REPLICATION

1. Place raw data in folder "OrigData" in same directory as "doFilesRep"
2. Add additional preparatory files to "doFilesRep" folder 
3. Create empty folders "Data" and "Analysis" in same directory as "OrigData" and "doFilesRep" 
4. Uncomment necessary lines in do files as desired (see Master file)
5. Run MasterRep.do



